﻿

--获得奖惩列表
CREATE proc [dbo].[proc_Employee_Award_Punish_GetItem]
(
	@Id int
)
as
	SELECT Id,EId,AContent,EntryPeople,EntryTime,EName,Temp,
	ISNULL(Reason,'') AS Reason,
	(SELECT d.DName from Department d WHERE d.Id=Did) AS DName,
	(SELECT c.CompanyName FROM Company c WHERE c.Id=Award_Punish.Cid) AS CName	
	 from Award_Punish WHERE Id=@Id 


